SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL AND c.isDisabled = 0 WHERE LISTINGSTATUS = 'L'AND (p.expirydate IS NULL or p.expirydate > now()) AND highlightAdvertPosition = 0 AND p.ADDRESSPOSTCODE IN (3054,3054,3053,3052,3068,8507,3051,8557,8538,3057,3056,8500,3065,3003,3066,3050,8388,8390,3031,8393,3010,8394,3005,3002,3001,3000,3055,3008,8396,3067,3070,8399,8005,8001,8002,8003,8004,8061,8006,8007,8008,8009,8010,8045,8051,8060,8066,8069,8070,8071,8100,8101,8102,8103,8107,8108,8111,8120,8205,8383,8386,3039,3006,3071,3078,3032,3011,3058,3205,3141,3121,3101,8865) UNION SELECT p.* FROM property p INNER JOIN customer c ON p.customerid = c.customerid AND c.archived IS NULL WHERE p.listingStatus IN ('L')AND c.isDisabled = 0 AND highlightAdvertPosition > 0 AND (p.expirydate IS NULL or p.expirydate > now())AND p.addressstate RLIKE 'VIC'ORDER BY highlightAdvertPosition DESC